Tabela UserDefinition

Definicja tabeli UserDefinition

Name

UserDefinition

Code

UserDefinition

Comment

PL: Definicja kont uzytkowników
EN: User list's definition


Lista kolumn tabeli UserDefinition

Name

Code

PersonID

PersonID

LanguageID

LanguageID

Description

Description

Active

Active

StartDT

StartDT

StopDT

StopDT

LoginText

LoginText

Password

Password

PasswordExpireDT

PasswordExpireDT

PasswordChange

PasswordChange

LastSuccessfulLoginDT

LastSuccessfulLoginDT

LastFailedLoginDT

LastFailedLoginDT

NumFailedLoginAttempts

NumFailedLoginAttempts

PasswordChangeDT

PasswordChangeDT

Code

Code

AuthenticateQuestion

AuthenticateQuestion

AuthenticateAnswer

AuthenticateAnswer

CertificateNo

CertificateNo


Kolumna PersonID tabeli UserDefinition

Definicja kolumny PersonID tabeli UserDefinition

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna LanguageID tabeli UserDefinition

Definicja kolumny LanguageID tabeli UserDefinition

Name

LanguageID

Code

LanguageID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Description tabeli UserDefinition

Definicja kolumny Description tabeli UserDefinition

Name

Description

Code

Description

Data Type

VARCHAR2(48)

Mandatory

No

Comment

PL: Opis wiersza
EN: Record's description
DE: Die Beschreibung des Rekord


Kolumna Active tabeli UserDefinition

Definicja kolumny Active tabeli UserDefinition

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna StartDT tabeli UserDefinition

Definicja kolumny StartDT tabeli UserDefinition

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli UserDefinition

Definicja kolumny StopDT tabeli UserDefinition

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna LoginText tabeli UserDefinition

Definicja kolumny LoginText tabeli UserDefinition

Name

LoginText

Code

LoginText

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna Password tabeli UserDefinition

Definicja kolumny Password tabeli UserDefinition

Name

Password

Code

Password

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna PasswordExpireDT tabeli UserDefinition

Definicja kolumny PasswordExpireDT tabeli UserDefinition

Name

PasswordExpireDT

Code

PasswordExpireDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna PasswordChange tabeli UserDefinition

Definicja kolumny PasswordChange tabeli UserDefinition

Name

PasswordChange

Code

PasswordChange

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna LastSuccessfulLoginDT tabeli UserDefinition

Definicja kolumny LastSuccessfulLoginDT tabeli UserDefinition

Name

LastSuccessfulLoginDT

Code

LastSuccessfulLoginDT

Data Type

DATE

Mandatory

No

Comment

Data ostatniego udanego logowania


Kolumna LastFailedLoginDT tabeli UserDefinition

Definicja kolumny LastFailedLoginDT tabeli UserDefinition

Name

LastFailedLoginDT

Code

LastFailedLoginDT

Data Type

DATE

Mandatory

No

Comment

Data ostatniego nieudanego logowania


Kolumna NumFailedLoginAttempts tabeli UserDefinition

Definicja kolumny NumFailedLoginAttempts tabeli UserDefinition

Name

NumFailedLoginAttempts

Code

NumFailedLoginAttempts

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna PasswordChangeDT tabeli UserDefinition

Definicja kolumny PasswordChangeDT tabeli UserDefinition

Name

PasswordChangeDT

Code

PasswordChangeDT

Data Type

DATE

Mandatory

No

Comment

Data ostatniej zmiany hasla


Kolumna Code tabeli UserDefinition

Definicja kolumny Code tabeli UserDefinition

Name

Code

Code

Code

Data Type

VARCHAR2(64)

Mandatory

No

Comment

PL: Kod wiersza
EN: Record's code
DE: Der code des Rekord


Kolumna AuthenticateQuestion tabeli UserDefinition

Definicja kolumny AuthenticateQuestion tabeli UserDefinition

Name

AuthenticateQuestion

Code

AuthenticateQuestion

Data Type

VARCHAR2(128)

Mandatory

No

Comment

Pytanie uwierzytelniajace uzytkownika


Kolumna AuthenticateAnswer tabeli UserDefinition

Definicja kolumny AuthenticateAnswer tabeli UserDefinition

Name

AuthenticateAnswer

Code

AuthenticateAnswer

Data Type

VARCHAR2(64)

Mandatory

No

Comment

Odpowiedz uzytkownika


Kolumna CertificateNo tabeli UserDefinition

Definicja kolumny CertificateNo tabeli UserDefinition

Name

CertificateNo

Code

CertificateNo

Data Type

VARCHAR2(50)

Mandatory

No

Comment

Numer certyfikatu karty kryptograficznej


Lista kluczy tabeli UserDefinition

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli UserDefinition

Definicja klucza Identifier_1 tabeli UserDefinition

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment